Skip Headers

Oracle® OLAP Reference 10g Release 2 (10.2) Part Number B14350-01 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# ALL_OLAP2_AWS

`ALL_OLAP2_AWS` provides a list of all the analytic workspaces accessible to the current user. This includes both standard form and non-standard analytic workspaces.

Column | Datatype | NULL | Description
--- | --- | --- | ---
`OWNER` | `VARCHAR2(30)` |  | Owner of the analytic workspace.
`AW` | `VARCHAR2(30)` |  | Name of the analytic workspace.
`AW_NUMBER` | `NUMBER` |  | Unique identifier for the analytic workspace.
`AW_VERSION` | `VARCHAR2(4)` |  | The version of the Database in which the analytic workspace was created. If the version is 10.1 or higher, the workspace is in 10g storage format. Earlier versions are in 9i format. To upgrade to 10g storage format, use the `DBMS_AW`.`CONVERT` procedure, as described in "Converting an Analytic Workspace to Oracle 10g Storage Format" .
`SF_VERSION` | `CHAR(8)` |  | The version of the Database in which the standard form metadata was created. To upgrade to 10.1.0.3.1 standard form, use the `DBMS_AWM.CREATE_DYNAMIC_AW_ACCESS` procedure, as described in "CREATE_DYNAMIC_AW_ACCESS Procedure".